Agent Central Host Computer/Agent - Central Host Computer.iso/_SETUP.1/install.sql

Text File | 2000-05-26 | 3KB | 186 lines

/* RCSVER $Id: install.sql,v 1.23 2000-05-26 09:14:47-05 randy Exp $ */
/* *************************************************************************
*        Copyright (C) 1999, Agent Systems, Inc. All Rights Reserved.
*
* Name:         install.sql
* Date:         03/19/1999
* memo:         Randy Wood
* Description:  Install all tables.
* Changes:
************************************************************************* */
/* ---------------------------------------- */
/* Set the log file and set exit upon error */
/* ---------------------------------------- */
SPOOL C:\TEMP\SQLLOG1.TXT
WHENEVER SQLERROR EXIT 11 ROLLBACK
    /* Level 0 - No dependencies */
@acctdaytotals
@actual_sound
@adjustment
@batch
@batchtotals
@bitdef
@bus
@cashboxloc
@cashboxtotals
@cashclose
@close_batch
@closenum
@close_excp
@conclefx
@configbuttons
@configset
@converr
@curtypes
@dayofweek
@dir1list
@dir2list
@dlconfig
@driver_context
@equiptype
@fare_context
@fbfiles
@fixedbuttons
@garage
@hwtypes
@inplcefx
@introefx
@loadok
@master
@matchconfig
@mrcconvert
@mrorphans
@mrpend
@operator_context
@probe_context
@probehist
@prorphans
@prpend
@rectypes
@report_cat
@reports
@rptfaremap
@rptheaders
@rptnames
@rteusage
@seq_adjustments
@seq_bus
@seq_configsets
@seq_convert
@seq_fareclass
@seq_garage
@sound_class
@subbatch
@subsystems
@tableversions
@tmpseq
@tuningtypes
@users
@waycodes

    /* Level 1 - Dependencies Level 0 */
@alarmsg
@currency
@custdisp
@fareclasses
@faredescriptions
@faresets
@fbtuning
@global_id
@invaltok
@jamclr
@mrreconcile
@nolog
@ocucmnd
@ocukeys
@optypes
@passwords
@prompts
@routes
@runs
@sound
@status
@subsecurities
@tallygrp
@tallys
@tallytypes
@tokens
@trapconvert
@trips

    /* Level 2 - Dependencies Level 1 */
@cashbox
@convert
@farebox
@faretable
@faretimes
@holidays
@operations
@opsecurities
@sec_levels
@tuningentry
@tuningvals
@wayfares
@wayfset

    /* Level 3 - Dependencies Level 2 */
@convexcp
@mstrrec

    /* Level 4 - Dependencies Level 3 */
    /* These are record types that depend on the mstrrec table */
@alarmact
@alarmclr
@badcbid
@bitstat
@cbdoorc
@cbdooro
@cbdooru
@cbinsert
@cblatch
@cbremov
@cbunlatch
@cmdinit
@conpwrb
@conpwre
@cscrash
@cscurcnt
@cskeycnt
@csposto
@curacc
@curstate
@escapek
@fareentr
@fbconfig
@fberror
@fbpwrfal
@fschng
@invalsec
@jcdoorc
@jcdooro
@probefail
@probesucc
@psettime
@revision
@rtechng
@sboveroff
@sboveron
@settime
@shftend
@shftrele
@shftrels
@shftstrt
@staket
@startup
@supersec
@tallyuse
@wayevnt
@wayissue
@waysvc
@wayvalpass
/* ------------------ */
/* Close the log file */
/* ------------------ */
SPOOL OFF
COMMIT;
EXIT;